An open-source scientific and technical publishing system
Artwork from “Hello, Quarto” keynote by Julia Lowndes and Mine Çetinkaya-Rundel, presented at RStudio Conference 2022. Illustrated by Allison Horst.
statsrhian.github.io/example-quarto-report/example-report.html
#| code-line-numbers: "1-8|6-8|2-3"
---
title: "NHS Workforce Statistics for `r params$ics_name`"
subtitle: "Data for `r params$month_year`"
author: "Maria Garcia"
date: "2023-09-28"
params:
ics_name: "North East and North Cumbria"
month_year: "April 2023"
---
Read in the data
filename = glue("NHS Workforce Statistics, {params$month_year} England and Organisation.xlsx")
Clean the data
#| code-line-numbers: "3"
staff_group =
staff_group |>
filter(`ICS name` == params$ics_name) |>
select(`Organisation name`, `Total`,
`HCHS Doctors`, `Nurses & health visitors`,
`Midwives`, `Ambulance staff`)
Add insight
The table below shows the total number of doctors and nurses for each organisation within `r params$ics_name`. We can see that the organisation with the most midwives is the `r pull(max_midwives, "Organisation name")` with `r round(max_midwives$Midwives)` staff.
#| code-line-numbers: "8"
---
title: "NHS Workforce Statistics for `r params$ics_name`"
subtitle: "Data for `r params$month_year`"
author: "Maria Garcia"
date: "2023-09-28"
params:
ics_name: "North East and North Cumbria"
month_year: "May 2023"
#| code-line-numbers: "7"
---
title: "NHS Workforce Statistics for `r params$ics_name`"
subtitle: "Data for `r params$month_year`"
author: "Maria Garcia"
date: "2023-09-28"
params:
ics_name: "Lancashire and South Cumbria"
month_year: "May 2023"